7.10 删除图书
1、 在html界面新增链接（href="/book/delete/{{ book.id }}）：
<td>
<a href="" class="btn btn-primary btn-xs">
<i class="fa-solid fa-pen" style="color:primary"></i>
</a>
<a href="/book/delete/{{ book.id }}" class="btn btn-danger btn-xs">
<i class="fa-solid fa-trash fa-1x" aria-hidden="true"></i>
</a>
</td>
2、 在url里面新增name 和delete：
urlpatterns=[
path("list",views.book_list,name="book_list"),
path("create",views.book_create),
path("delete/<int:book_id>", views.book_delete)
]
3、 在view里面新增：
def book_delete(request,book_id):
conn = pymysql.connect(
host="127.0.0.1",
port=3306,
user="root",
password="502",
db="bms",
charset="utf8",
cursorclass=pymysql.cursors.DictCursor
)
with conn.cursor() as cursor:
sql='delete from book where id= %s'
cursor.execute(sql,book_id)
conn.commit()
return redirect("book_list")